Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 1219694 |
| Missing cells | 3700183 |
| Missing cells (%) | 9.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.2 GiB |
| Average record size in memory | 1.0 KiB |
Variable types
| Numeric | 12 |
|---|---|
| Boolean | 4 |
| Categorical | 14 |
| Unsupported | 2 |
Net_Sales_Proceeds has constant value "False" | Constant |
Non_MI_Recoveries has constant value "FRM" | Constant |
Estimated_Loan_to_Value_(ELTV) has constant value "True" | Constant |
Current_Month_Modification_Cost has constant value "False" | Constant |
Expenses has a high cardinality: 54 distinct values | High cardinality |
Taxes_and_Insurance has a high cardinality: 1219694 distinct values | High cardinality |
Monthly_Reporting_Period is highly overall correlated with Current_Loan_Delinquency_Status | High correlation |
Current_Loan_Delinquency_Status is highly overall correlated with Monthly_Reporting_Period and 1 other fields | High correlation |
Loan_Age is highly overall correlated with Expenses | High correlation |
Remaining_Months_to_Legal_Maturity is highly overall correlated with Zero_Balance_Code and 2 other fields | High correlation |
Zero_Balance_Code is highly overall correlated with Remaining_Months_to_Legal_Maturity and 1 other fields | High correlation |
Current_Deferred_UPB is highly overall correlated with Remaining_Months_to_Legal_Maturity and 3 other fields | High correlation |
Due_Date_of_Last_Paid_Installment_(DDLPI) is highly overall correlated with Actual_Loss_Calculation | High correlation |
Maintenance_and_Preservation_Costs is highly overall correlated with Expenses | High correlation |
Actual_Loss_Calculation is highly overall correlated with Current_Loan_Delinquency_Status and 1 other fields | High correlation |
Current_Actual_UPB is highly overall correlated with Current_Deferred_UPB and 1 other fields | High correlation |
MI_Recoveries is highly overall correlated with Step_Modification_Flag and 1 other fields | High correlation |
Expenses is highly overall correlated with Loan_Age and 1 other fields | High correlation |
Miscellaneous_Expenses is highly overall correlated with Current_Actual_UPB | High correlation |
Step_Modification_Flag is highly overall correlated with MI_Recoveries and 1 other fields | High correlation |
Deferred_Payment_Plan is highly overall correlated with MI_Recoveries and 1 other fields | High correlation |
Interest_Bearing_UPB is highly overall correlated with Remaining_Months_to_Legal_Maturity and 1 other fields | High correlation |
Current_Actual_UPB is highly imbalanced (56.6%) | Imbalance |
Defect_Settlement_Date is highly imbalanced (92.1%) | Imbalance |
Modification_Flag is highly imbalanced (67.2%) | Imbalance |
Modification_Cost is highly imbalanced (54.8%) | Imbalance |
Delinquent_Accrued_Interest is highly imbalanced (85.1%) | Imbalance |
Interest_Bearing_UPB is highly imbalanced (52.0%) | Imbalance |
Loan_Age has 95617 (7.8%) missing values | Missing |
Estimated_Loan_to_Value_(ELTV) has 1165178 (95.5%) missing values | Missing |
Zero_Balance_Removal_UPB has 1219694 (100.0%) missing values | Missing |
Delinquency_Due_to_Disaster has 1219694 (100.0%) missing values | Missing |
Loan_Sequence_Number is highly skewed (γ1 = 76.65065439) | Skewed |
Monthly_Reporting_Period is highly skewed (γ1 = 41.23688602) | Skewed |
Taxes_and_Insurance is uniformly distributed | Uniform |
Taxes_and_Insurance has unique values | Unique |
Zero_Balance_Removal_UPB is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Delinquency_Due_to_Disaster is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Remaining_Months_to_Legal_Maturity has 1006523 (82.5%) zeros | Zeros |
Reproduction
| Analysis started | 2023-10-06 14:00:30.565677 |
|---|---|
| Analysis finished | 2023-10-06 14:03:22.336422 |
| Duration | 2 minutes and 51.77 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
Loan_Sequence_Number
Real number (ℝ)
| Distinct | 240 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 758.45945 |
| Minimum | 300 |
|---|---|
| Maximum | 9999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 MiB |
Quantile statistics
| Minimum | 300 |
|---|---|
| 5-th percentile | 677 |
| Q1 | 730 |
| median | 767 |
| Q3 | 791 |
| 95-th percentile | 810 |
| Maximum | 9999 |
| Range | 9699 |
| Interquartile range (IQR) | 61 |
Descriptive statistics
| Standard deviation | 98.111925 |
|---|---|
| Coefficient of variation (CV) | 0.12935685 |
| Kurtosis | 7222.6701 |
| Mean | 758.45945 |
| Median Absolute Deviation (MAD) | 29 |
| Skewness | 76.650654 |
| Sum | 9.2508844 × 108 |
| Variance | 9625.9499 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 801 | 16676 | 1.4% |
| 790 | 15896 | 1.3% |
| 787 | 15396 | 1.3% |
| 797 | 15323 | 1.3% |
| 791 | 15225 | 1.2% |
| 809 | 15183 | 1.2% |
| 796 | 14733 | 1.2% |
| 800 | 14561 | 1.2% |
| 798 | 14445 | 1.2% |
| 793 | 14124 | 1.2% |
| Other values (230) | 1068132 |
| Value | Count | Frequency (%) |
| 300 | 1 | < 0.1% |
| 571 | 1 | < 0.1% |
| 600 | 15 | |
| 601 | 10 | |
| 602 | 13 | |
| 603 | 9 | |
| 604 | 14 | |
| 605 | 18 | |
| 606 | 15 | |
| 607 | 15 |
| Value | Count | Frequency (%) |
| 9999 | 112 | |
| 839 | 2 | < 0.1% |
| 835 | 1 | < 0.1% |
| 834 | 5 | < 0.1% |
| 833 | 2 | < 0.1% |
| 832 | 58 | < 0.1% |
| 831 | 12 | < 0.1% |
| 830 | 26 | < 0.1% |
| 829 | 195 | |
| 828 | 60 | < 0.1% |
Monthly_Reporting_Period
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 202104.11 |
| Minimum | 202102 |
|---|---|
| Maximum | 202301 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 MiB |
Quantile statistics
| Minimum | 202102 |
|---|---|
| 5-th percentile | 202103 |
| Q1 | 202103 |
| median | 202104 |
| Q3 | 202105 |
| 95-th percentile | 202105 |
| Maximum | 202301 |
| Range | 199 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.9899804 |
|---|---|
| Coefficient of variation (CV) | 9.8463134 × 10-6 |
| Kurtosis | 2090.9932 |
| Mean | 202104.11 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 41.236886 |
| Sum | 2.4650517 × 1011 |
| Variance | 3.9600219 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 202105 | 439802 | |
| 202104 | 395399 | |
| 202103 | 369832 | |
| 202106 | 12147 | 1.0% |
| 202102 | 1943 | 0.2% |
| 202203 | 97 | < 0.1% |
| 202202 | 92 | < 0.1% |
| 202201 | 87 | < 0.1% |
| 202111 | 56 | < 0.1% |
| 202204 | 52 | < 0.1% |
| Other values (13) | 187 | < 0.1% |
| Value | Count | Frequency (%) |
| 202102 | 1943 | 0.2% |
| 202103 | 369832 | |
| 202104 | 395399 | |
| 202105 | 439802 | |
| 202106 | 12147 | 1.0% |
| 202107 | 5 | < 0.1% |
| 202108 | 12 | < 0.1% |
| 202109 | 20 | < 0.1% |
| 202110 | 30 | < 0.1% |
| 202111 | 56 | < 0.1% |
| Value | Count | Frequency (%) |
| 202301 | 1 | < 0.1% |
| 202211 | 1 | < 0.1% |
| 202210 | 7 | < 0.1% |
| 202209 | 7 | < 0.1% |
| 202208 | 5 | < 0.1% |
| 202207 | 10 | < 0.1% |
| 202206 | 15 | < 0.1% |
| 202205 | 27 | < 0.1% |
| 202204 | 52 | |
| 202203 | 97 |
Current_Actual_UPB
Boolean
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
| False | |
|---|---|
| True | 108948 |
| Value | Count | Frequency (%) |
| False | 1110746 | |
| True | 108948 | 8.9% |
Current_Loan_Delinquency_Status
Real number (ℝ)
| Distinct | 283 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 204743.05 |
| Minimum | 202803 |
|---|---|
| Maximum | 205212 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 MiB |
Quantile statistics
| Minimum | 202803 |
|---|---|
| 5-th percentile | 203602 |
| Q1 | 204402 |
| median | 205102 |
| Q3 | 205104 |
| 95-th percentile | 205104 |
| Maximum | 205212 |
| Range | 2409 |
| Interquartile range (IQR) | 702 |
Descriptive statistics
| Standard deviation | 616.82575 |
|---|---|
| Coefficient of variation (CV) | 0.0030126822 |
| Kurtosis | -0.20495481 |
| Mean | 204743.05 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -1.2566847 |
| Sum | 2.4972387 × 1011 |
| Variance | 380474 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 205104 | 313160 | |
| 205103 | 286612 | |
| 205102 | 276290 | |
| 203604 | 82566 | 6.8% |
| 203603 | 68469 | 5.6% |
| 203602 | 57573 | 4.7% |
| 204104 | 27650 | 2.3% |
| 204103 | 24270 | 2.0% |
| 204102 | 21452 | 1.8% |
| 205105 | 7433 | 0.6% |
| Other values (273) | 54219 | 4.4% |
| Value | Count | Frequency (%) |
| 202803 | 1 | < 0.1% |
| 202804 | 3 | < 0.1% |
| 202805 | 1 | < 0.1% |
| 202806 | 1 | < 0.1% |
| 202808 | 1 | < 0.1% |
| 202901 | 1 | < 0.1% |
| 202902 | 70 | |
| 202903 | 94 | |
| 202904 | 127 | |
| 202905 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 205212 | 1 | < 0.1% |
| 205210 | 1 | < 0.1% |
| 205209 | 7 | < 0.1% |
| 205208 | 7 | < 0.1% |
| 205207 | 3 | < 0.1% |
| 205206 | 7 | < 0.1% |
| 205205 | 13 | < 0.1% |
| 205204 | 26 | < 0.1% |
| 205203 | 45 | |
| 205202 | 93 |
Loan_Age
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 408 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 95617 |
| Missing (%) | 7.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30517.519 |
| Minimum | 10180 |
|---|---|
| Maximum | 49740 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 MiB |
Quantile statistics
| Minimum | 10180 |
|---|---|
| 5-th percentile | 12060 |
| Q1 | 19430 |
| median | 33340 |
| Q3 | 40140 |
| 95-th percentile | 47664 |
| Maximum | 49740 |
| Range | 39560 |
| Interquartile range (IQR) | 20710 |
Descriptive statistics
| Standard deviation | 11322.608 |
|---|---|
| Coefficient of variation (CV) | 0.37101994 |
| Kurtosis | -1.2287425 |
| Mean | 30517.519 |
| Median Absolute Deviation (MAD) | 8600 |
| Skewness | -0.1987437 |
| Sum | 3.4304041 × 1010 |
| Variance | 1.2820146 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 31084 | 36818 | 3.0% |
| 16984 | 34887 | 2.9% |
| 38060 | 34623 | 2.8% |
| 47894 | 31034 | 2.5% |
| 12060 | 25815 | 2.1% |
| 19740 | 22853 | 1.9% |
| 40140 | 22464 | 1.8% |
| 33460 | 20612 | 1.7% |
| 42644 | 20347 | 1.7% |
| 26420 | 19886 | 1.6% |
| Other values (398) | 854738 | |
| (Missing) | 95617 | 7.8% |
| Value | Count | Frequency (%) |
| 10180 | 310 | < 0.1% |
| 10380 | 1 | < 0.1% |
| 10420 | 2108 | |
| 10500 | 130 | < 0.1% |
| 10540 | 569 | < 0.1% |
| 10580 | 1877 | |
| 10740 | 2832 | |
| 10780 | 205 | < 0.1% |
| 10900 | 2689 | |
| 11020 | 235 | < 0.1% |
| Value | Count | Frequency (%) |
| 49740 | 660 | 0.1% |
| 49700 | 786 | 0.1% |
| 49660 | 985 | 0.1% |
| 49620 | 1687 | 0.1% |
| 49500 | 1 | < 0.1% |
| 49420 | 556 | < 0.1% |
| 49340 | 4399 | |
| 49180 | 1715 | 0.1% |
| 49020 | 633 | 0.1% |
| 48900 | 1417 | 0.1% |
Remaining_Months_to_Legal_Maturity
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.0664224 |
| Minimum | 0 |
|---|---|
| Maximum | 55 |
| Zeros | 1006523 |
| Zeros (%) | 82.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 30 |
| Maximum | 55 |
| Range | 55 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 9.3919546 |
|---|---|
| Coefficient of variation (CV) | 2.3096358 |
| Kurtosis | 2.5661946 |
| Mean | 4.0664224 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.0621656 |
| Sum | 4959791 |
| Variance | 88.208811 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1006523 | |
| 25 | 79157 | 6.5% |
| 30 | 69593 | 5.7% |
| 12 | 50326 | 4.1% |
| 35 | 6065 | 0.5% |
| 6 | 5495 | 0.5% |
| 18 | 1396 | 0.1% |
| 16 | 1090 | 0.1% |
| 15 | 12 | < 0.1% |
| 20 | 6 | < 0.1% |
| Other values (21) | 31 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 1006523 | |
| 6 | 5495 | 0.5% |
| 12 | 50326 | 4.1% |
| 14 | 2 | < 0.1% |
| 15 | 12 | < 0.1% |
| 16 | 1090 | 0.1% |
| 18 | 1396 | 0.1% |
| 20 | 6 | < 0.1% |
| 22 | 1 | < 0.1% |
| 23 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 55 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 49 | 1 | < 0.1% |
| 47 | 1 | < 0.1% |
| 45 | 2 | |
| 43 | 1 | < 0.1% |
| 42 | 1 | < 0.1% |
| 38 | 1 | < 0.1% |
| 37 | 1 | < 0.1% |
| 36 | 4 |
Defect_Settlement_Date
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.5 MiB |
| 1 | |
|---|---|
| 2 | 16687 |
| 3 | 3616 |
| 4 | 2915 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1219694 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 1196476 | |
| 2 | 16687 | 1.4% |
| 3 | 3616 | 0.3% |
| 4 | 2915 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 1196476 | |
| 2 | 16687 | 1.4% |
| 3 | 3616 | 0.3% |
| 4 | 2915 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1196476 | |
| 2 | 16687 | 1.4% |
| 3 | 3616 | 0.3% |
| 4 | 2915 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1219694 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1196476 | |
| 2 | 16687 | 1.4% |
| 3 | 3616 | 0.3% |
| 4 | 2915 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1219694 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 1196476 | |
| 2 | 16687 | 1.4% |
| 3 | 3616 | 0.3% |
| 4 | 2915 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1219694 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 1196476 | |
| 2 | 16687 | 1.4% |
| 3 | 3616 | 0.3% |
| 4 | 2915 | 0.2% |
Modification_Flag
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.5 MiB |
| P | |
|---|---|
| I | 65538 |
| S | 43101 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1219694 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | P |
|---|---|
| 2nd row | P |
| 3rd row | P |
| 4th row | P |
| 5th row | S |
Common Values
| Value | Count | Frequency (%) |
| P | 1111055 | |
| I | 65538 | 5.4% |
| S | 43101 | 3.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| p | 1111055 | |
| i | 65538 | 5.4% |
| s | 43101 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 1111055 | |
| I | 65538 | 5.4% |
| S | 43101 | 3.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1219694 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 1111055 | |
| I | 65538 | 5.4% |
| S | 43101 | 3.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1219694 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 1111055 | |
| I | 65538 | 5.4% |
| S | 43101 | 3.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1219694 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 1111055 | |
| I | 65538 | 5.4% |
| S | 43101 | 3.5% |
Zero_Balance_Code
Real number (ℝ)
| Distinct | 104 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 68.428521 |
| Minimum | 3 |
|---|---|
| Maximum | 999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 36 |
| Q1 | 58 |
| median | 71 |
| Q3 | 80 |
| 95-th percentile | 95 |
| Maximum | 999 |
| Range | 996 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 17.032429 |
|---|---|
| Coefficient of variation (CV) | 0.24890833 |
| Kurtosis | 7.3123924 |
| Mean | 68.428521 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | -0.46031166 |
| Sum | 83461856 |
| Variance | 290.10363 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 80 | 159436 | 13.1% |
| 75 | 75649 | 6.2% |
| 95 | 65453 | 5.4% |
| 70 | 55248 | 4.5% |
| 60 | 46423 | 3.8% |
| 90 | 40932 | 3.4% |
| 69 | 29352 | 2.4% |
| 74 | 27123 | 2.2% |
| 79 | 25466 | 2.1% |
| 85 | 24358 | 2.0% |
| Other values (94) | 670254 |
| Value | Count | Frequency (%) |
| 3 | 1 | < 0.1% |
| 4 | 3 | < 0.1% |
| 5 | 15 | < 0.1% |
| 6 | 29 | < 0.1% |
| 7 | 62 | < 0.1% |
| 8 | 76 | < 0.1% |
| 9 | 120 | < 0.1% |
| 10 | 163 | |
| 11 | 224 | |
| 12 | 318 |
| Value | Count | Frequency (%) |
| 999 | 1 | < 0.1% |
| 105 | 18 | < 0.1% |
| 104 | 29 | < 0.1% |
| 103 | 53 | < 0.1% |
| 102 | 235 | < 0.1% |
| 101 | 308 | < 0.1% |
| 100 | 450 | < 0.1% |
| 99 | 89 | < 0.1% |
| 98 | 49 | < 0.1% |
| 97 | 16119 |
Zero_Balance_Effective_Date
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.008357 |
| Minimum | 1 |
|---|---|
| Maximum | 999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 26 |
| median | 34 |
| Q3 | 41 |
| 95-th percentile | 48 |
| Maximum | 999 |
| Range | 998 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.993696 |
|---|---|
| Coefficient of variation (CV) | 0.33305796 |
| Kurtosis | 1562.3705 |
| Mean | 33.008357 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 17.60132 |
| Sum | 40260095 |
| Variance | 120.86135 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 45 | 43273 | 3.5% |
| 44 | 42989 | 3.5% |
| 43 | 42843 | 3.5% |
| 42 | 42243 | 3.5% |
| 41 | 41411 | 3.4% |
| 39 | 41142 | 3.4% |
| 38 | 41110 | 3.4% |
| 40 | 41045 | 3.4% |
| 37 | 40670 | 3.3% |
| 36 | 40612 | 3.3% |
| Other values (42) | 802356 |
| Value | Count | Frequency (%) |
| 1 | 64 | < 0.1% |
| 2 | 113 | < 0.1% |
| 3 | 171 | < 0.1% |
| 4 | 241 | < 0.1% |
| 5 | 382 | < 0.1% |
| 6 | 645 | 0.1% |
| 7 | 968 | 0.1% |
| 8 | 1511 | |
| 9 | 2287 | |
| 10 | 3411 |
| Value | Count | Frequency (%) |
| 999 | 32 | < 0.1% |
| 51 | 6 | < 0.1% |
| 50 | 20718 | |
| 49 | 23955 | |
| 48 | 23305 | |
| 47 | 23574 | |
| 46 | 25059 | |
| 45 | 43273 | |
| 44 | 42989 | |
| 43 | 42843 |
Current_Interest_Rate
Real number (ℝ)
| Distinct | 1071 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 291095.95 |
| Minimum | 12000 |
|---|---|
| Maximum | 1582000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 MiB |
Quantile statistics
| Minimum | 12000 |
|---|---|
| 5-th percentile | 100000 |
| Q1 | 179000 |
| median | 263000 |
| Q3 | 375000 |
| 95-th percentile | 548000 |
| Maximum | 1582000 |
| Range | 1570000 |
| Interquartile range (IQR) | 196000 |
Descriptive statistics
| Standard deviation | 148360.86 |
|---|---|
| Coefficient of variation (CV) | 0.50966307 |
| Kurtosis | 0.96798377 |
| Mean | 291095.95 |
| Median Absolute Deviation (MAD) | 94000 |
| Skewness | 0.95308568 |
| Sum | 3.5504799 × 1011 |
| Variance | 2.2010944 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 548000 | 19487 | 1.6% |
| 200000 | 10222 | 0.8% |
| 300000 | 9045 | 0.7% |
| 150000 | 7903 | 0.6% |
| 250000 | 7461 | 0.6% |
| 240000 | 6464 | 0.5% |
| 510000 | 6272 | 0.5% |
| 280000 | 6094 | 0.5% |
| 100000 | 6038 | 0.5% |
| 180000 | 5961 | 0.5% |
| Other values (1061) | 1134747 |
| Value | Count | Frequency (%) |
| 12000 | 1 | < 0.1% |
| 13000 | 2 | < 0.1% |
| 14000 | 1 | < 0.1% |
| 15000 | 2 | < 0.1% |
| 17000 | 2 | < 0.1% |
| 20000 | 8 | < 0.1% |
| 21000 | 4 | < 0.1% |
| 22000 | 10 | |
| 23000 | 13 | |
| 24000 | 23 |
| Value | Count | Frequency (%) |
| 1582000 | 4 | |
| 1581000 | 1 | < 0.1% |
| 1551000 | 1 | < 0.1% |
| 1538000 | 2 | |
| 1520000 | 1 | < 0.1% |
| 1500000 | 2 | |
| 1495000 | 1 | < 0.1% |
| 1493000 | 1 | < 0.1% |
| 1478000 | 1 | < 0.1% |
| 1473000 | 1 | < 0.1% |
Current_Deferred_UPB
Real number (ℝ)
| Distinct | 96 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 68.199353 |
| Minimum | 3 |
|---|---|
| Maximum | 101 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 36 |
| Q1 | 58 |
| median | 70 |
| Q3 | 80 |
| 95-th percentile | 95 |
| Maximum | 101 |
| Range | 98 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 17.049955 |
|---|---|
| Coefficient of variation (CV) | 0.25000171 |
| Kurtosis | 0.001959364 |
| Mean | 68.199353 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | -0.58672812 |
| Sum | 83182342 |
| Variance | 290.70096 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 80 | 158893 | 13.0% |
| 75 | 76040 | 6.2% |
| 95 | 65353 | 5.4% |
| 70 | 55505 | 4.6% |
| 60 | 47038 | 3.9% |
| 90 | 39526 | 3.2% |
| 69 | 29492 | 2.4% |
| 74 | 27128 | 2.2% |
| 79 | 25161 | 2.1% |
| 59 | 23800 | 2.0% |
| Other values (86) | 671758 |
| Value | Count | Frequency (%) |
| 3 | 1 | < 0.1% |
| 4 | 3 | < 0.1% |
| 5 | 15 | < 0.1% |
| 6 | 30 | < 0.1% |
| 7 | 63 | < 0.1% |
| 8 | 77 | < 0.1% |
| 9 | 124 | < 0.1% |
| 10 | 169 | |
| 11 | 230 | |
| 12 | 329 |
| Value | Count | Frequency (%) |
| 101 | 1 | < 0.1% |
| 97 | 16871 | 1.4% |
| 96 | 327 | < 0.1% |
| 95 | 65353 | |
| 94 | 3815 | 0.3% |
| 93 | 4065 | 0.3% |
| 92 | 4047 | 0.3% |
| 91 | 2920 | 0.2% |
| 90 | 39526 | |
| 89 | 7695 | 0.6% |
Due_Date_of_Last_Paid_Installment_(DDLPI)
Real number (ℝ)
| Distinct | 1637 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.7973943 |
| Minimum | 1.5 |
|---|---|
| Maximum | 6.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 MiB |
Quantile statistics
| Minimum | 1.5 |
|---|---|
| 5-th percentile | 2.25 |
| Q1 | 2.625 |
| median | 2.875 |
| Q3 | 2.99 |
| 95-th percentile | 3.375 |
| Maximum | 6.5 |
| Range | 5 |
| Interquartile range (IQR) | 0.365 |
Descriptive statistics
| Standard deviation | 0.33631568 |
|---|---|
| Coefficient of variation (CV) | 0.12022462 |
| Kurtosis | 2.7277912 |
| Mean | 2.7973943 |
| Median Absolute Deviation (MAD) | 0.125 |
| Skewness | 0.49359934 |
| Sum | 3411965.1 |
| Variance | 0.11310823 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.875 | 251124 | |
| 2.75 | 206922 | |
| 2.625 | 109609 | |
| 2.5 | 104228 | |
| 2.99 | 92882 | 7.6% |
| 3 | 70753 | 5.8% |
| 2.375 | 62782 | 5.1% |
| 2.25 | 58164 | 4.8% |
| 3.125 | 53926 | 4.4% |
| 3.25 | 35000 | 2.9% |
| Other values (1627) | 174304 |
| Value | Count | Frequency (%) |
| 1.5 | 2 | < 0.1% |
| 1.625 | 3 | < 0.1% |
| 1.75 | 1950 | |
| 1.751 | 1 | < 0.1% |
| 1.756 | 1 | < 0.1% |
| 1.766 | 1 | < 0.1% |
| 1.775 | 2 | < 0.1% |
| 1.799 | 2 | < 0.1% |
| 1.8 | 2 | < 0.1% |
| 1.802 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6.5 | 1 | < 0.1% |
| 6.125 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 5.875 | 3 | < 0.1% |
| 5.75 | 1 | < 0.1% |
| 5.625 | 2 | < 0.1% |
| 5.5 | 31 | |
| 5.49 | 2 | < 0.1% |
| 5.375 | 12 | < 0.1% |
| 5.25 | 68 |
MI_Recoveries
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.5 MiB |
| R | |
|---|---|
| C | |
| B |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1219694 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | R |
| 3rd row | R |
| 4th row | R |
| 5th row | R |
Common Values
| Value | Count | Frequency (%) |
| R | 713865 | |
| C | 342082 | |
| B | 163747 | 13.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| r | 713865 | |
| c | 342082 | |
| b | 163747 | 13.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 713865 | |
| C | 342082 | |
| B | 163747 | 13.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1219694 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 713865 | |
| C | 342082 | |
| B | 163747 | 13.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1219694 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 713865 | |
| C | 342082 | |
| B | 163747 | 13.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1219694 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 713865 | |
| C | 342082 | |
| B | 163747 | 13.4% |
Net_Sales_Proceeds
Boolean
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 1219694 |
Non_MI_Recoveries
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.8 MiB |
| FRM |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3659082 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FRM |
|---|---|
| 2nd row | FRM |
| 3rd row | FRM |
| 4th row | FRM |
| 5th row | FRM |
Common Values
| Value | Count | Frequency (%) |
| FRM | 1219694 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| frm | 1219694 |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 1219694 | |
| R | 1219694 | |
| M | 1219694 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3659082 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 1219694 | |
| R | 1219694 | |
| M | 1219694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3659082 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 1219694 | |
| R | 1219694 | |
| M | 1219694 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3659082 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| F | 1219694 | |
| R | 1219694 | |
| M | 1219694 |
Expenses
Categorical
HIGH CARDINALITY  HIGH CORRELATION 
| Distinct | 54 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.6 MiB |
| CA | |
|---|---|
| TX | 74595 |
| FL | 72294 |
| IL | 51483 |
| AZ | 45836 |
| Other values (49) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 2439388 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NJ |
|---|---|
| 2nd row | CO |
| 3rd row | DE |
| 4th row | KY |
| 5th row | MA |
Common Values
| Value | Count | Frequency (%) |
| CA | 183913 | 15.1% |
| TX | 74595 | 6.1% |
| FL | 72294 | 5.9% |
| IL | 51483 | 4.2% |
| AZ | 45836 | 3.8% |
| WA | 42037 | 3.4% |
| OH | 40598 | 3.3% |
| VA | 40530 | 3.3% |
| CO | 39707 | 3.3% |
| MI | 39033 | 3.2% |
| Other values (44) | 589668 |
Length
| Value | Count | Frequency (%) |
| ca | 183913 | 15.1% |
| tx | 74595 | 6.1% |
| fl | 72294 | 5.9% |
| il | 51483 | 4.2% |
| az | 45836 | 3.8% |
| wa | 42037 | 3.4% |
| oh | 40598 | 3.3% |
| va | 40530 | 3.3% |
| co | 39707 | 3.3% |
| mi | 39033 | 3.2% |
| Other values (44) | 589668 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 460542 | |
| C | 291306 | |
| N | 212183 | 8.7% |
| M | 172417 | 7.1% |
| I | 161501 | 6.6% |
| L | 147230 | 6.0% |
| T | 138181 | 5.7% |
| O | 136290 | 5.6% |
| X | 74595 | 3.1% |
| F | 72294 | 3.0% |
| Other values (14) | 572849 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2439388 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 460542 | |
| C | 291306 | |
| N | 212183 | 8.7% |
| M | 172417 | 7.1% |
| I | 161501 | 6.6% |
| L | 147230 | 6.0% |
| T | 138181 | 5.7% |
| O | 136290 | 5.6% |
| X | 74595 | 3.1% |
| F | 72294 | 3.0% |
| Other values (14) | 572849 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2439388 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 460542 | |
| C | 291306 | |
| N | 212183 | 8.7% |
| M | 172417 | 7.1% |
| I | 161501 | 6.6% |
| L | 147230 | 6.0% |
| T | 138181 | 5.7% |
| O | 136290 | 5.6% |
| X | 74595 | 3.1% |
| F | 72294 | 3.0% |
| Other values (14) | 572849 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2439388 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 460542 | |
| C | 291306 | |
| N | 212183 | 8.7% |
| M | 172417 | 7.1% |
| I | 161501 | 6.6% |
| L | 147230 | 6.0% |
| T | 138181 | 5.7% |
| O | 136290 | 5.6% |
| X | 74595 | 3.1% |
| F | 72294 | 3.0% |
| Other values (14) | 572849 |
Legal_Costs
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 68.6 MiB |
| SF | |
|---|---|
| PU | |
| CO | |
| MH | 4190 |
| CP | 1457 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 2439388 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PU |
|---|---|
| 2nd row | SF |
| 3rd row | SF |
| 4th row | SF |
| 5th row | SF |
Common Values
| Value | Count | Frequency (%) |
| SF | 784789 | |
| PU | 338101 | |
| CO | 91157 | 7.5% |
| MH | 4190 | 0.3% |
| CP | 1457 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| sf | 784789 | |
| pu | 338101 | |
| co | 91157 | 7.5% |
| mh | 4190 | 0.3% |
| cp | 1457 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 784789 | |
| F | 784789 | |
| P | 339558 | |
| U | 338101 | |
| C | 92614 | 3.8% |
| O | 91157 | 3.7% |
| M | 4190 | 0.2% |
| H | 4190 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2439388 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 784789 | |
| F | 784789 | |
| P | 339558 | |
| U | 338101 | |
| C | 92614 | 3.8% |
| O | 91157 | 3.7% |
| M | 4190 | 0.2% |
| H | 4190 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2439388 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 784789 | |
| F | 784789 | |
| P | 339558 | |
| U | 338101 | |
| C | 92614 | 3.8% |
| O | 91157 | 3.7% |
| M | 4190 | 0.2% |
| H | 4190 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2439388 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 784789 | |
| F | 784789 | |
| P | 339558 | |
| U | 338101 | |
| C | 92614 | 3.8% |
| O | 91157 | 3.7% |
| M | 4190 | 0.2% |
| H | 4190 | 0.2% |
Maintenance_and_Preservation_Costs
Real number (ℝ)
| Distinct | 888 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55443.636 |
| Minimum | 600 |
|---|---|
| Maximum | 99900 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 MiB |
Quantile statistics
| Minimum | 600 |
|---|---|
| 5-th percentile | 6600 |
| Q1 | 29900 |
| median | 55100 |
| Q3 | 85200 |
| 95-th percentile | 97100 |
| Maximum | 99900 |
| Range | 99300 |
| Interquartile range (IQR) | 55300 |
Descriptive statistics
| Standard deviation | 30630.112 |
|---|---|
| Coefficient of variation (CV) | 0.55245497 |
| Kurtosis | -1.3493143 |
| Mean | 55443.636 |
| Median Absolute Deviation (MAD) | 27800 |
| Skewness | -0.12120529 |
| Sum | 6.7624271 × 1010 |
| Variance | 9.3820378 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 94500 | 17057 | 1.4% |
| 85200 | 13359 | 1.1% |
| 84000 | 12312 | 1.0% |
| 75000 | 12126 | 1.0% |
| 30000 | 12007 | 1.0% |
| 98000 | 10968 | 0.9% |
| 60000 | 10567 | 0.9% |
| 85300 | 10455 | 0.9% |
| 20100 | 9860 | 0.8% |
| 60600 | 9438 | 0.8% |
| Other values (878) | 1101545 |
| Value | Count | Frequency (%) |
| 600 | 39 | < 0.1% |
| 700 | 55 | < 0.1% |
| 800 | 87 | < 0.1% |
| 900 | 112 | < 0.1% |
| 1000 | 1221 | |
| 1100 | 311 | < 0.1% |
| 1200 | 225 | < 0.1% |
| 1300 | 146 | < 0.1% |
| 1400 | 915 | 0.1% |
| 1500 | 2368 |
| Value | Count | Frequency (%) |
| 99900 | 53 | < 0.1% |
| 99800 | 217 | < 0.1% |
| 99700 | 179 | < 0.1% |
| 99600 | 634 | 0.1% |
| 99500 | 1117 | |
| 99400 | 72 | < 0.1% |
| 99300 | 1481 | |
| 99200 | 1714 | |
| 99100 | 315 | < 0.1% |
| 99000 | 819 |
Taxes_and_Insurance
Categorical
HIGH CARDINALITY  UNIFORM  UNIQUE 
| Distinct | 1219694 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.3 MiB |
| F20Q41275812 | 1 |
|---|---|
| F21Q12090498 | 1 |
| F21Q12090496 | 1 |
| F21Q12090495 | 1 |
| F21Q12090494 | 1 |
| Other values (1219689) |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 14636328 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1219694 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | F20Q41275812 |
|---|---|
| 2nd row | F21Q11275813 |
| 3rd row | F21Q11275814 |
| 4th row | F21Q11275815 |
| 5th row | F21Q11275816 |
Common Values
| Value | Count | Frequency (%) |
| F20Q41275812 | 1 | < 0.1% |
| F21Q12090498 | 1 | < 0.1% |
| F21Q12090496 | 1 | < 0.1% |
| F21Q12090495 | 1 | < 0.1% |
| F21Q12090494 | 1 | < 0.1% |
| F21Q12090493 | 1 | < 0.1% |
| F21Q12090492 | 1 | < 0.1% |
| F21Q12090491 | 1 | < 0.1% |
| F21Q12090490 | 1 | < 0.1% |
| F21Q12090489 | 1 | < 0.1% |
| Other values (1219684) | 1219684 |
Length
| Value | Count | Frequency (%) |
| f20q41275812 | 1 | < 0.1% |
| f21q11275816 | 1 | < 0.1% |
| f21q11275818 | 1 | < 0.1% |
| f21q11275819 | 1 | < 0.1% |
| f21q11275820 | 1 | < 0.1% |
| f21q11275821 | 1 | < 0.1% |
| f21q11275822 | 1 | < 0.1% |
| f21q11275823 | 1 | < 0.1% |
| f21q11275824 | 1 | < 0.1% |
| f21q11275825 | 1 | < 0.1% |
| Other values (1219684) | 1219684 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 3869502 | |
| 2 | 2447989 | |
| F | 1219694 | 8.3% |
| Q | 1219694 | 8.3% |
| 3 | 807148 | 5.5% |
| 4 | 804763 | 5.5% |
| 8 | 717300 | 4.9% |
| 9 | 715024 | 4.9% |
| 7 | 712029 | 4.9% |
| 6 | 708246 | 4.8% |
| Other values (2) | 1414939 | 9.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12196940 | |
| Uppercase Letter | 2439388 | 16.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 3869502 | |
| 2 | 2447989 | |
| 3 | 807148 | 6.6% |
| 4 | 804763 | 6.6% |
| 8 | 717300 | 5.9% |
| 9 | 715024 | 5.9% |
| 7 | 712029 | 5.8% |
| 6 | 708246 | 5.8% |
| 5 | 707547 | 5.8% |
| 0 | 707392 | 5.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 1219694 | |
| Q | 1219694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 12196940 | |
| Latin | 2439388 | 16.7% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 3869502 | |
| 2 | 2447989 | |
| 3 | 807148 | 6.6% |
| 4 | 804763 | 6.6% |
| 8 | 717300 | 5.9% |
| 9 | 715024 | 5.9% |
| 7 | 712029 | 5.8% |
| 6 | 708246 | 5.8% |
| 5 | 707547 | 5.8% |
| 0 | 707392 | 5.8% |
Latin
| Value | Count | Frequency (%) |
| F | 1219694 | |
| Q | 1219694 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14636328 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 3869502 | |
| 2 | 2447989 | |
| F | 1219694 | 8.3% |
| Q | 1219694 | 8.3% |
| 3 | 807148 | 5.5% |
| 4 | 804763 | 5.5% |
| 8 | 717300 | 4.9% |
| 9 | 715024 | 4.9% |
| 7 | 712029 | 4.9% |
| 6 | 708246 | 4.8% |
| Other values (2) | 1414939 | 9.7% |
Miscellaneous_Expenses
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.5 MiB |
| N | |
|---|---|
| P | |
| C |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1219694 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | P |
|---|---|
| 2nd row | C |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
Common Values
| Value | Count | Frequency (%) |
| N | 665575 | |
| P | 277384 | |
| C | 276735 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| n | 665575 | |
| p | 277384 | |
| c | 276735 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 665575 | |
| P | 277384 | |
| C | 276735 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1219694 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 665575 | |
| P | 277384 | |
| C | 276735 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1219694 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 665575 | |
| P | 277384 | |
| C | 276735 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1219694 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 665575 | |
| P | 277384 | |
| C | 276735 |
Actual_Loss_Calculation
Real number (ℝ)
| Distinct | 247 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 316.80677 |
| Minimum | 85 |
|---|---|
| Maximum | 366 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 MiB |
Quantile statistics
| Minimum | 85 |
|---|---|
| 5-th percentile | 180 |
| Q1 | 276 |
| median | 360 |
| Q3 | 360 |
| 95-th percentile | 360 |
| Maximum | 366 |
| Range | 281 |
| Interquartile range (IQR) | 84 |
Descriptive statistics
| Standard deviation | 74.017242 |
|---|---|
| Coefficient of variation (CV) | 0.23363529 |
| Kurtosis | -0.20440694 |
| Mean | 316.80677 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.2570806 |
| Sum | 3.8640732 × 108 |
| Variance | 5478.5521 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 360 | 885358 | |
| 180 | 212052 | 17.4% |
| 240 | 74428 | 6.1% |
| 300 | 18499 | 1.5% |
| 120 | 12464 | 1.0% |
| 324 | 2272 | 0.2% |
| 348 | 1824 | 0.1% |
| 144 | 1135 | 0.1% |
| 336 | 1124 | 0.1% |
| 312 | 813 | 0.1% |
| Other values (237) | 9725 | 0.8% |
| Value | Count | Frequency (%) |
| 85 | 6 | < 0.1% |
| 90 | 1 | < 0.1% |
| 96 | 293 | |
| 97 | 1 | < 0.1% |
| 98 | 1 | < 0.1% |
| 99 | 1 | < 0.1% |
| 100 | 1 | < 0.1% |
| 101 | 2 | < 0.1% |
| 102 | 1 | < 0.1% |
| 106 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 366 | 8 | < 0.1% |
| 365 | 2 | < 0.1% |
| 364 | 1 | < 0.1% |
| 360 | 885358 | |
| 359 | 23 | < 0.1% |
| 358 | 3 | < 0.1% |
| 357 | 8 | < 0.1% |
| 356 | 16 | < 0.1% |
| 355 | 19 | < 0.1% |
| 354 | 64 | < 0.1% |
Modification_Cost
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.5 MiB |
| 1 | |
|---|---|
| 2 | |
| 3 | 6252 |
| 4 | 1054 |
| 5 | 18 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1219694 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 2 |
| 3rd row | 1 |
| 4th row | 2 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 631435 | |
| 2 | 580935 | |
| 3 | 6252 | 0.5% |
| 4 | 1054 | 0.1% |
| 5 | 18 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 631435 | |
| 2 | 580935 | |
| 3 | 6252 | 0.5% |
| 4 | 1054 | 0.1% |
| 5 | 18 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 631435 | |
| 2 | 580935 | |
| 3 | 6252 | 0.5% |
| 4 | 1054 | 0.1% |
| 5 | 18 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1219694 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 631435 | |
| 2 | 580935 | |
| 3 | 6252 | 0.5% |
| 4 | 1054 | 0.1% |
| 5 | 18 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1219694 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 631435 | |
| 2 | 580935 | |
| 3 | 6252 | 0.5% |
| 4 | 1054 | 0.1% |
| 5 | 18 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1219694 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 631435 | |
| 2 | 580935 | |
| 3 | 6252 | 0.5% |
| 4 | 1054 | 0.1% |
| 5 | 18 | < 0.1% |
Step_Modification_Flag
Categorical
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 89.6 MiB |
| Other sellers | |
|---|---|
| QUICKEN LOANS, LLC | |
| WELLS FARGO BANK, N.A. | |
| PENNYMAC CORP. | |
| UNITED WHOLESALE MORTGAGE, LLC | |
| Other values (16) |
Length
| Max length | 41 |
|---|---|
| Median length | 40 |
| Mean length | 20.06181 |
| Min length | 10 |
Characters and Unicode
| Total characters | 24469269 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | WELLS FARGO BANK, N.A. |
|---|---|
| 2nd row | Other sellers |
| 3rd row | Other sellers |
| 4th row | Other sellers |
| 5th row | Other sellers |
Common Values
| Value | Count | Frequency (%) |
| Other sellers | 438820 | |
| QUICKEN LOANS, LLC | 109365 | 9.0% |
| WELLS FARGO BANK, N.A. | 61002 | 5.0% |
| PENNYMAC CORP. | 60711 | 5.0% |
| UNITED WHOLESALE MORTGAGE, LLC | 58230 | 4.8% |
| JPMORGAN CHASE BANK, NATIONAL ASSOCIATION | 54860 | 4.5% |
| LOANDEPOT.COM, LLC | 49895 | 4.1% |
| NATIONSTAR MORTGAGE LLC DBA MR. COOPER | 48642 | 4.0% |
| NEWREZ LLC | 44794 | 3.7% |
| AMERIHOME MORTGAGE COMPANY, LLC | 41636 | 3.4% |
| Other values (11) | 251739 |
Length
| Value | Count | Frequency (%) |
| other | 438820 | 12.3% |
| sellers | 438820 | 12.3% |
| llc | 381577 | 10.7% |
| mortgage | 213662 | 6.0% |
| bank | 204126 | 5.7% |
| loans | 138778 | 3.9% |
| quicken | 109365 | 3.1% |
| n.a | 89471 | 2.5% |
| corporation | 83511 | 2.3% |
| pennymac | 76868 | 2.2% |
| Other values (36) | 1393849 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2349153 | 9.6% | |
| O | 1953775 | 8.0% |
| A | 1868194 | 7.6% |
| N | 1621062 | 6.6% |
| L | 1340635 | 5.5% |
| e | 1316460 | 5.4% |
| E | 1305181 | 5.3% |
| C | 1135070 | 4.6% |
| R | 996367 | 4.1% |
| r | 877640 | 3.6% |
| Other values (24) | 9705732 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 16353673 | |
| Lowercase Letter | 4827020 | 19.7% |
| Space Separator | 2349153 | 9.6% |
| Other Punctuation | 939423 | 3.8% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 1953775 | |
| A | 1868194 | |
| N | 1621062 | |
| L | 1340635 | 8.2% |
| E | 1305181 | 8.0% |
| C | 1135070 | 6.9% |
| R | 996367 | 6.1% |
| I | 841302 | 5.1% |
| T | 812730 | 5.0% |
| S | 656434 | 4.0% |
| Other values (15) | 3822923 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1316460 | |
| r | 877640 | |
| s | 877640 | |
| l | 877640 | |
| t | 438820 | 9.1% |
| h | 438820 | 9.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 493346 | |
| . | 446077 |
Space Separator
| Value | Count | Frequency (%) |
| 2349153 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 21180693 | |
| Common | 3288576 | 13.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 1953775 | 9.2% |
| A | 1868194 | 8.8% |
| N | 1621062 | 7.7% |
| L | 1340635 | 6.3% |
| e | 1316460 | 6.2% |
| E | 1305181 | 6.2% |
| C | 1135070 | 5.4% |
| R | 996367 | 4.7% |
| r | 877640 | 4.1% |
| s | 877640 | 4.1% |
| Other values (21) | 7888669 |
Common
| Value | Count | Frequency (%) |
| 2349153 | ||
| , | 493346 | 15.0% |
| . | 446077 | 13.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 24469269 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2349153 | 9.6% | |
| O | 1953775 | 8.0% |
| A | 1868194 | 7.6% |
| N | 1621062 | 6.6% |
| L | 1340635 | 5.5% |
| e | 1316460 | 5.4% |
| E | 1305181 | 5.3% |
| C | 1135070 | 4.6% |
| R | 996367 | 4.1% |
| r | 877640 | 3.6% |
| Other values (24) | 9705732 |
Deferred_Payment_Plan
Categorical
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 92.5 MiB |
| Other servicers | |
|---|---|
| JPMORGAN CHASE BANK, NATIONAL ASSOCIATION | |
| ROCKET MORTGAGE, LLC | |
| WELLS FARGO BANK, N.A. | |
| PENNYMAC CORP. | |
| Other values (20) |
Length
| Max length | 41 |
|---|---|
| Median length | 32 |
| Mean length | 22.522049 |
| Min length | 10 |
Characters and Unicode
| Total characters | 27470008 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | WELLS FARGO BANK, N.A. |
|---|---|
| 2nd row | U.S. BANK N.A. |
| 3rd row | U.S. BANK N.A. |
| 4th row | U.S. BANK N.A. |
| 5th row | Other servicers |
Common Values
| Value | Count | Frequency (%) |
| Other servicers | 358972 | |
| JPMORGAN CHASE BANK, NATIONAL ASSOCIATION | 111702 | 9.2% |
| ROCKET MORTGAGE, LLC | 82436 | 6.8% |
| WELLS FARGO BANK, N.A. | 60938 | 5.0% |
| PENNYMAC CORP. | 60710 | 5.0% |
| UNITED WHOLESALE MORTGAGE, LLC | 49831 | 4.1% |
| NATIONSTAR MORTGAGE LLC DBA MR. COOPER | 49592 | 4.1% |
| MATRIX FINANCIAL SERVICES CORPORATION | 38439 | 3.2% |
| LOANDEPOT.COM, LLC | 37050 | 3.0% |
| NEWREZ LLC | 36152 | 3.0% |
| Other values (15) | 333872 |
Length
| Value | Count | Frequency (%) |
| other | 358972 | 9.4% |
| servicers | 358972 | 9.4% |
| llc | 333408 | 8.7% |
| bank | 291813 | 7.7% |
| mortgage | 284035 | 7.4% |
| corporation | 145443 | 3.8% |
| national | 127624 | 3.3% |
| association | 127624 | 3.3% |
| jpmorgan | 111702 | 2.9% |
| chase | 111702 | 2.9% |
| Other values (40) | 1561864 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2593465 | 9.4% | |
| A | 2376307 | 8.7% |
| O | 2331642 | 8.5% |
| N | 1833892 | 6.7% |
| R | 1358338 | 4.9% |
| C | 1319891 | 4.8% |
| E | 1314739 | 4.8% |
| L | 1295231 | 4.7% |
| I | 1190861 | 4.3% |
| T | 1161581 | 4.2% |
| Other values (26) | 10694061 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 19286083 | |
| Lowercase Letter | 4666636 | 17.0% |
| Space Separator | 2593465 | 9.4% |
| Other Punctuation | 923824 | 3.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2376307 | |
| O | 2331642 | |
| N | 1833892 | |
| R | 1358338 | 7.0% |
| C | 1319891 | 6.8% |
| E | 1314739 | 6.8% |
| L | 1295231 | 6.7% |
| I | 1190861 | 6.2% |
| T | 1161581 | 6.0% |
| S | 832811 | 4.3% |
| Other values (15) | 4270790 |
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 1076916 | |
| e | 1076916 | |
| s | 717944 | |
| h | 358972 | 7.7% |
| c | 358972 | 7.7% |
| t | 358972 | 7.7% |
| i | 358972 | 7.7% |
| v | 358972 | 7.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 489796 | |
| . | 434028 |
Space Separator
| Value | Count | Frequency (%) |
| 2593465 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 23952719 | |
| Common | 3517289 | 12.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 2376307 | 9.9% |
| O | 2331642 | 9.7% |
| N | 1833892 | 7.7% |
| R | 1358338 | 5.7% |
| C | 1319891 | 5.5% |
| E | 1314739 | 5.5% |
| L | 1295231 | 5.4% |
| I | 1190861 | 5.0% |
| T | 1161581 | 4.8% |
| r | 1076916 | 4.5% |
| Other values (23) | 8693321 |
Common
| Value | Count | Frequency (%) |
| 2593465 | ||
| , | 489796 | 13.9% |
| . | 434028 | 12.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 27470008 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2593465 | 9.4% | |
| A | 2376307 | 8.7% |
| O | 2331642 | 8.5% |
| N | 1833892 | 6.7% |
| R | 1358338 | 4.9% |
| C | 1319891 | 4.8% |
| E | 1314739 | 4.8% |
| L | 1295231 | 4.7% |
| I | 1190861 | 4.3% |
| T | 1161581 | 4.2% |
| Other values (26) | 10694061 |
Estimated_Loan_to_Value_(ELTV)
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1165178 |
| Missing (%) | 95.5% |
| Memory size | 2.3 MiB |
| True | 54516 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 54516 | 4.5% |
| (Missing) | 1165178 |
Zero_Balance_Removal_UPB
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1219694 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 9.3 MiB |
Delinquent_Accrued_Interest
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.5 MiB |
| 9 | |
|---|---|
| H | 42747 |
| F | 1894 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1219694 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9 |
|---|---|
| 2nd row | 9 |
| 3rd row | 9 |
| 4th row | 9 |
| 5th row | 9 |
Common Values
| Value | Count | Frequency (%) |
| 9 | 1175053 | |
| H | 42747 | 3.5% |
| F | 1894 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 9 | 1175053 | |
| h | 42747 | 3.5% |
| f | 1894 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 1175053 | |
| H | 42747 | 3.5% |
| F | 1894 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1175053 | |
| Uppercase Letter | 44641 | 3.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 42747 | |
| F | 1894 | 4.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 1175053 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1175053 | |
| Latin | 44641 | 3.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| H | 42747 | |
| F | 1894 | 4.2% |
Common
| Value | Count | Frequency (%) |
| 9 | 1175053 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1219694 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 9 | 1175053 | |
| H | 42747 | 3.5% |
| F | 1894 | 0.2% |
Delinquency_Due_to_Disaster
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 1219694 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 9.3 MiB |
Borrower_Assistance_Status_Code
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.5 MiB |
| 2 | |
|---|---|
| 1 | |
| 3 | 31670 |
| 9 | 176 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1219694 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 1 |
| 4th row | 2 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 623360 | |
| 1 | 564488 | |
| 3 | 31670 | 2.6% |
| 9 | 176 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 623360 | |
| 1 | 564488 | |
| 3 | 31670 | 2.6% |
| 9 | 176 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 623360 | |
| 1 | 564488 | |
| 3 | 31670 | 2.6% |
| 9 | 176 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1219694 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 623360 | |
| 1 | 564488 | |
| 3 | 31670 | 2.6% |
| 9 | 176 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1219694 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 623360 | |
| 1 | 564488 | |
| 3 | 31670 | 2.6% |
| 9 | 176 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1219694 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 623360 | |
| 1 | 564488 | |
| 3 | 31670 | 2.6% |
| 9 | 176 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 1219694 |
Interest_Bearing_UPB
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.5 MiB |
| 7 | |
|---|---|
| N | |
| Y | 25429 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1219694 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 7 |
|---|---|
| 2nd row | 7 |
| 3rd row | Y |
| 4th row | 7 |
| 5th row | 7 |
Common Values
| Value | Count | Frequency (%) |
| 7 | 1006523 | |
| N | 187742 | 15.4% |
| Y | 25429 | 2.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 7 | 1006523 | |
| n | 187742 | 15.4% |
| y | 25429 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 1006523 | |
| N | 187742 | 15.4% |
| Y | 25429 | 2.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1006523 | |
| Uppercase Letter | 213171 | 17.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 187742 | |
| Y | 25429 | 11.9% |
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 1006523 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1006523 | |
| Latin | 213171 | 17.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 187742 | |
| Y | 25429 | 11.9% |
Common
| Value | Count | Frequency (%) |
| 7 | 1006523 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1219694 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7 | 1006523 | |
| N | 187742 | 15.4% |
| Y | 25429 | 2.1% |
| Loan_Sequence_Number | Monthly_Reporting_Period | Current_Loan_Delinquency_Status | Loan_Age | Remaining_Months_to_Legal_Maturity | Zero_Balance_Code | Zero_Balance_Effective_Date | Current_Interest_Rate | Current_Deferred_UPB | Due_Date_of_Last_Paid_Installment_(DDLPI) | Maintenance_and_Preservation_Costs | Actual_Loss_Calculation | Current_Actual_UPB | Defect_Settlement_Date | Modification_Flag | MI_Recoveries | Expenses | Legal_Costs | Miscellaneous_Expenses | Modification_Cost | Step_Modification_Flag | Deferred_Payment_Plan | Delinquent_Accrued_Interest | Borrower_Assistance_Status_Code | Interest_Bearing_UPB | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loan_Sequence_Number | 1.000 | -0.018 | -0.077 | -0.001 | -0.099 | -0.162 | -0.183 | 0.055 | -0.160 | -0.228 | 0.025 | -0.081 | 0.007 | 0.000 | 0.002 | 0.005 | 0.004 | 0.002 | 0.010 | 0.002 | 0.007 | 0.009 | 0.000 | 0.005 | 0.003 |
| Monthly_Reporting_Period | -0.018 | 1.000 | 0.512 | -0.010 | 0.002 | 0.001 | 0.008 | -0.029 | 0.001 | 0.106 | -0.021 | -0.037 | 0.005 | 0.000 | 0.004 | 0.008 | 0.016 | 0.005 | 0.008 | 0.006 | 0.012 | 0.013 | 0.002 | 0.010 | 0.007 |
| Current_Loan_Delinquency_Status | -0.077 | 0.512 | 1.000 | 0.023 | 0.177 | 0.265 | 0.086 | 0.164 | 0.264 | 0.485 | 0.053 | 0.799 | 0.166 | 0.018 | 0.045 | 0.066 | 0.053 | 0.034 | 0.193 | 0.033 | 0.061 | 0.064 | 0.050 | 0.090 | 0.154 |
| Loan_Age | -0.001 | -0.010 | 0.023 | 1.000 | -0.030 | -0.050 | 0.030 | 0.084 | -0.049 | 0.007 | 0.162 | 0.036 | 0.023 | 0.050 | 0.041 | 0.073 | 0.561 | 0.110 | 0.047 | 0.016 | 0.062 | 0.061 | 0.029 | 0.039 | 0.045 |
| Remaining_Months_to_Legal_Maturity | -0.099 | 0.002 | 0.177 | -0.030 | 1.000 | 0.659 | 0.068 | 0.069 | 0.661 | 0.069 | -0.059 | 0.212 | 0.477 | 0.029 | 0.087 | 0.049 | 0.048 | 0.037 | 0.365 | 0.032 | 0.046 | 0.042 | 0.392 | 0.171 | 0.763 |
| Zero_Balance_Code | -0.162 | 0.001 | 0.265 | -0.050 | 0.659 | 1.000 | 0.099 | 0.159 | 0.993 | 0.208 | -0.118 | 0.320 | 0.026 | 0.005 | 0.003 | 0.006 | 0.014 | 0.002 | 0.012 | 0.004 | 0.019 | 0.017 | 0.103 | 0.006 | 0.014 |
| Zero_Balance_Effective_Date | -0.183 | 0.008 | 0.086 | 0.030 | 0.068 | 0.099 | 1.000 | 0.062 | 0.098 | 0.130 | 0.045 | 0.098 | 0.000 | 0.006 | 0.019 | 0.002 | 0.000 | 0.000 | 0.002 | 0.004 | 0.002 | 0.001 | 0.000 | 0.004 | 0.001 |
| Current_Interest_Rate | 0.055 | -0.029 | 0.164 | 0.084 | 0.069 | 0.159 | 0.062 | 1.000 | 0.152 | -0.064 | 0.159 | 0.218 | 0.032 | 0.119 | 0.074 | 0.117 | 0.164 | 0.074 | 0.055 | 0.068 | 0.059 | 0.075 | 0.074 | 0.072 | 0.060 |
| Current_Deferred_UPB | -0.160 | 0.001 | 0.264 | -0.049 | 0.661 | 0.993 | 0.098 | 0.152 | 1.000 | 0.208 | -0.118 | 0.319 | 0.500 | 0.035 | 0.091 | 0.054 | 0.081 | 0.042 | 0.403 | 0.036 | 0.050 | 0.049 | 0.178 | 0.202 | 0.706 |
| Due_Date_of_Last_Paid_Installment_(DDLPI) | -0.228 | 0.106 | 0.485 | 0.007 | 0.069 | 0.208 | 0.130 | -0.064 | 0.208 | 1.000 | 0.023 | 0.502 | 0.067 | 0.083 | 0.239 | 0.062 | 0.040 | 0.031 | 0.152 | 0.025 | 0.075 | 0.082 | 0.049 | 0.116 | 0.088 |
| Maintenance_and_Preservation_Costs | 0.025 | -0.021 | 0.053 | 0.162 | -0.059 | -0.118 | 0.045 | 0.159 | -0.118 | 0.023 | 1.000 | 0.079 | 0.057 | 0.072 | 0.077 | 0.142 | 0.948 | 0.174 | 0.101 | 0.034 | 0.101 | 0.109 | 0.057 | 0.075 | 0.084 |
| Actual_Loss_Calculation | -0.081 | -0.037 | 0.799 | 0.036 | 0.212 | 0.320 | 0.098 | 0.218 | 0.319 | 0.502 | 0.079 | 1.000 | 0.166 | 0.018 | 0.045 | 0.066 | 0.053 | 0.034 | 0.192 | 0.033 | 0.061 | 0.064 | 0.050 | 0.090 | 0.154 |
| Current_Actual_UPB | 0.007 | 0.005 | 0.166 | 0.023 | 0.477 | 0.026 | 0.000 | 0.032 | 0.500 | 0.067 | 0.057 | 0.166 | 1.000 | 0.016 | 0.098 | 0.065 | 0.077 | 0.092 | 0.577 | 0.066 | 0.114 | 0.099 | 0.233 | 0.249 | 0.414 |
| Defect_Settlement_Date | 0.000 | 0.000 | 0.018 | 0.050 | 0.029 | 0.005 | 0.006 | 0.119 | 0.035 | 0.083 | 0.072 | 0.018 | 0.016 | 1.000 | 0.186 | 0.015 | 0.092 | 0.059 | 0.012 | 0.021 | 0.025 | 0.026 | 0.007 | 0.075 | 0.031 |
| Modification_Flag | 0.002 | 0.004 | 0.045 | 0.041 | 0.087 | 0.003 | 0.019 | 0.074 | 0.091 | 0.239 | 0.077 | 0.045 | 0.098 | 0.186 | 1.000 | 0.027 | 0.105 | 0.078 | 0.100 | 0.038 | 0.075 | 0.080 | 0.043 | 0.164 | 0.074 |
| MI_Recoveries | 0.005 | 0.008 | 0.066 | 0.073 | 0.049 | 0.006 | 0.002 | 0.117 | 0.054 | 0.062 | 0.142 | 0.066 | 0.065 | 0.015 | 0.027 | 1.000 | 0.187 | 0.052 | 0.067 | 0.018 | 0.600 | 0.581 | 0.050 | 0.068 | 0.040 |
| Expenses | 0.004 | 0.016 | 0.053 | 0.561 | 0.048 | 0.014 | 0.000 | 0.164 | 0.081 | 0.040 | 0.948 | 0.053 | 0.077 | 0.092 | 0.105 | 0.187 | 1.000 | 0.230 | 0.125 | 0.045 | 0.102 | 0.096 | 0.099 | 0.106 | 0.093 |
| Legal_Costs | 0.002 | 0.005 | 0.034 | 0.110 | 0.037 | 0.002 | 0.000 | 0.074 | 0.042 | 0.031 | 0.174 | 0.034 | 0.092 | 0.059 | 0.078 | 0.052 | 0.230 | 1.000 | 0.106 | 0.046 | 0.072 | 0.069 | 0.046 | 0.051 | 0.046 |
| Miscellaneous_Expenses | 0.010 | 0.008 | 0.193 | 0.047 | 0.365 | 0.012 | 0.002 | 0.055 | 0.403 | 0.152 | 0.101 | 0.192 | 0.577 | 0.012 | 0.100 | 0.067 | 0.125 | 0.106 | 1.000 | 0.040 | 0.173 | 0.169 | 0.111 | 0.336 | 0.324 |
| Modification_Cost | 0.002 | 0.006 | 0.033 | 0.016 | 0.032 | 0.004 | 0.004 | 0.068 | 0.036 | 0.025 | 0.034 | 0.033 | 0.066 | 0.021 | 0.038 | 0.018 | 0.045 | 0.046 | 0.040 | 1.000 | 0.024 | 0.023 | 0.071 | 0.017 | 0.039 |
| Step_Modification_Flag | 0.007 | 0.012 | 0.061 | 0.062 | 0.046 | 0.019 | 0.002 | 0.059 | 0.050 | 0.075 | 0.101 | 0.061 | 0.114 | 0.025 | 0.075 | 0.600 | 0.102 | 0.072 | 0.173 | 0.024 | 1.000 | 0.864 | 0.149 | 0.140 | 0.078 |
| Deferred_Payment_Plan | 0.009 | 0.013 | 0.064 | 0.061 | 0.042 | 0.017 | 0.001 | 0.075 | 0.049 | 0.082 | 0.109 | 0.064 | 0.099 | 0.026 | 0.080 | 0.581 | 0.096 | 0.069 | 0.169 | 0.023 | 0.864 | 1.000 | 0.141 | 0.133 | 0.075 |
| Delinquent_Accrued_Interest | 0.000 | 0.002 | 0.050 | 0.029 | 0.392 | 0.103 | 0.000 | 0.074 | 0.178 | 0.049 | 0.057 | 0.050 | 0.233 | 0.007 | 0.043 | 0.050 | 0.099 | 0.046 | 0.111 | 0.071 | 0.149 | 0.141 | 1.000 | 0.049 | 0.151 |
| Borrower_Assistance_Status_Code | 0.005 | 0.010 | 0.090 | 0.039 | 0.171 | 0.006 | 0.004 | 0.072 | 0.202 | 0.116 | 0.075 | 0.090 | 0.249 | 0.075 | 0.164 | 0.068 | 0.106 | 0.051 | 0.336 | 0.017 | 0.140 | 0.133 | 0.049 | 1.000 | 0.185 |
| Interest_Bearing_UPB | 0.003 | 0.007 | 0.154 | 0.045 | 0.763 | 0.014 | 0.001 | 0.060 | 0.706 | 0.088 | 0.084 | 0.154 | 0.414 | 0.031 | 0.074 | 0.040 | 0.093 | 0.046 | 0.324 | 0.039 | 0.078 | 0.075 | 0.151 | 0.185 | 1.000 |
| Loan_Sequence_Number | Monthly_Reporting_Period | Current_Actual_UPB | Current_Loan_Delinquency_Status | Loan_Age | Remaining_Months_to_Legal_Maturity | Defect_Settlement_Date | Modification_Flag | Zero_Balance_Code | Zero_Balance_Effective_Date | Current_Interest_Rate | Current_Deferred_UPB | Due_Date_of_Last_Paid_Installment_(DDLPI) | MI_Recoveries | Net_Sales_Proceeds | Non_MI_Recoveries | Expenses | Legal_Costs | Maintenance_and_Preservation_Costs | Taxes_and_Insurance | Miscellaneous_Expenses | Actual_Loss_Calculation | Modification_Cost | Step_Modification_Flag | Deferred_Payment_Plan | Estimated_Loan_to_Value_(ELTV) | Zero_Balance_Removal_UPB | Delinquent_Accrued_Interest | Delinquency_Due_to_Disaster | Borrower_Assistance_Status_Code | Current_Month_Modification_Cost | Interest_Bearing_UPB | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 725 | 202103 | Y | 205102 | 15804.0 | 0 | 1 | P | 80 | 30 | 298000 | 80 | 2.625 | C | N | FRM | NJ | PU | 8000 | F20Q41275812 | P | 360 | 1 | WELLS FARGO BANK, N.A. | WELLS FARGO BANK, N.A. | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 1 | 737 | 202103 | N | 205102 | NaN | 0 | 1 | P | 74 | 27 | 280000 | 74 | 2.500 | R | N | FRM | CO | SF | 81200 | F21Q11275813 | C | 360 | 2 | Other sellers | U.S. BANK N.A. | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 2 | 744 | 202105 | N | 204104 | 48864.0 | 6 | 1 | P | 85 | 34 | 285000 | 85 | 2.625 | R | N | FRM | DE | SF | 19800 | F21Q11275814 | N | 240 | 1 | Other sellers | U.S. BANK N.A. | NaN | NaN | 9 | NaN | 1 | N | Y |
| 3 | 676 | 202104 | N | 204103 | NaN | 0 | 1 | P | 79 | 23 | 146000 | 79 | 3.000 | R | N | FRM | KY | SF | 40400 | F21Q11275815 | N | 240 | 2 | Other sellers | U.S. BANK N.A. | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 4 | 765 | 202103 | N | 203602 | 12700.0 | 0 | 1 | S | 60 | 43 | 312000 | 60 | 2.125 | R | N | FRM | MA | SF | 2600 | F21Q11275816 | N | 180 | 2 | Other sellers | Other servicers | NaN | NaN | 9 | NaN | 1 | N | 7 |
| 5 | 686 | 202103 | N | 205102 | 19780.0 | 0 | 1 | P | 80 | 39 | 292000 | 80 | 3.375 | R | N | FRM | IA | SF | 50300 | F21Q11275817 | N | 360 | 2 | Other sellers | Other servicers | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 6 | 762 | 202103 | N | 205102 | NaN | 0 | 1 | P | 80 | 20 | 352000 | 80 | 2.625 | R | N | FRM | CO | SF | 81200 | F21Q11275818 | C | 360 | 2 | Other sellers | U.S. BANK N.A. | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 7 | 647 | 202104 | N | 205103 | NaN | 0 | 1 | P | 80 | 34 | 339000 | 80 | 3.500 | B | N | FRM | KY | SF | 40400 | F21Q11275819 | N | 360 | 2 | Other sellers | U.S. BANK N.A. | NaN | NaN | 9 | NaN | 1 | N | 7 |
| 8 | 786 | 202103 | N | 205102 | NaN | 0 | 1 | P | 77 | 16 | 215000 | 77 | 2.750 | R | N | FRM | VT | SF | 5800 | F21Q11275820 | C | 360 | 2 | Other sellers | Other servicers | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 9 | 749 | 202103 | Y | 205102 | 28740.0 | 30 | 1 | P | 93 | 45 | 149000 | 93 | 3.000 | R | N | FRM | NY | CO | 12500 | F21Q11275821 | P | 360 | 1 | Other sellers | Other servicers | NaN | NaN | 9 | NaN | 2 | N | N |
| Loan_Sequence_Number | Monthly_Reporting_Period | Current_Actual_UPB | Current_Loan_Delinquency_Status | Loan_Age | Remaining_Months_to_Legal_Maturity | Defect_Settlement_Date | Modification_Flag | Zero_Balance_Code | Zero_Balance_Effective_Date | Current_Interest_Rate | Current_Deferred_UPB | Due_Date_of_Last_Paid_Installment_(DDLPI) | MI_Recoveries | Net_Sales_Proceeds | Non_MI_Recoveries | Expenses | Legal_Costs | Maintenance_and_Preservation_Costs | Taxes_and_Insurance | Miscellaneous_Expenses | Actual_Loss_Calculation | Modification_Cost | Step_Modification_Flag | Deferred_Payment_Plan | Estimated_Loan_to_Value_(ELTV) | Zero_Balance_Removal_UPB | Delinquent_Accrued_Interest | Delinquency_Due_to_Disaster | Borrower_Assistance_Status_Code | Current_Month_Modification_Cost | Interest_Bearing_UPB | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1219684 | 704 | 202210 | N | 205209 | 25060.0 | 0 | 1 | P | 69 | 43 | 276000 | 69 | 4.625 | R | N | FRM | MS | SF | 39400 | F21Q12497610 | N | 360 | 2 | Other sellers | PHH MORTGAGE CORPORATION | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 1219685 | 807 | 202208 | N | 205203 | 38060.0 | 0 | 1 | P | 58 | 20 | 426000 | 58 | 5.150 | R | N | FRM | AZ | SF | 85200 | F21Q12497611 | N | 356 | 1 | Other sellers | Other servicers | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 1219686 | 816 | 202207 | N | 205201 | 31540.0 | 0 | 1 | P | 60 | 38 | 447000 | 60 | 4.050 | R | N | FRM | WI | SF | 53500 | F21Q12497612 | N | 355 | 1 | Other sellers | Other servicers | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 1219687 | 778 | 202204 | N | 205203 | 34060.0 | 0 | 1 | P | 39 | 17 | 80000 | 39 | 3.250 | R | N | FRM | WV | SF | 26500 | F21Q12497613 | N | 360 | 2 | Other sellers | Other servicers | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 1219688 | 666 | 202209 | N | 205208 | 35380.0 | 25 | 1 | P | 90 | 38 | 408000 | 90 | 3.750 | C | N | FRM | LA | PU | 70000 | F21Q12497614 | N | 360 | 2 | JPMORGAN CHASE BANK, NATIONAL ASSOCIATION | JPMORGAN CHASE BANK, NATIONAL ASSOCIATION | NaN | NaN | 9 | NaN | 2 | N | N |
| 1219689 | 732 | 202211 | N | 205210 | 12940.0 | 0 | 1 | P | 79 | 41 | 252000 | 79 | 3.125 | C | N | FRM | LA | SF | 70800 | F21Q12497615 | N | 360 | 1 | JPMORGAN CHASE BANK, NATIONAL ASSOCIATION | JPMORGAN CHASE BANK, NATIONAL ASSOCIATION | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 1219690 | 803 | 202203 | N | 205202 | 14540.0 | 30 | 1 | P | 93 | 29 | 204000 | 93 | 3.250 | R | N | FRM | KY | SF | 42100 | F21Q12497616 | N | 360 | 1 | Other sellers | Other servicers | NaN | NaN | 9 | NaN | 2 | N | N |
| 1219691 | 780 | 202301 | N | 205212 | 27260.0 | 0 | 1 | S | 66 | 25 | 510000 | 66 | 6.500 | R | N | FRM | FL | PU | 32200 | F21Q12497618 | N | 360 | 1 | Other sellers | Other servicers | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 1219692 | 789 | 202210 | N | 205209 | 34940.0 | 0 | 1 | P | 55 | 48 | 189000 | 55 | 3.125 | R | N | FRM | FL | SF | 34100 | F21Q12497619 | P | 360 | 2 | CROSSCOUNTRY MORTGAGE, LLC | CROSSCOUNTRY MORTGAGE, LLC | NaN | NaN | 9 | NaN | 2 | N | 7 |
| 1219693 | 681 | 202209 | N | 205208 | 38940.0 | 12 | 1 | P | 85 | 33 | 423000 | 85 | 5.875 | R | N | FRM | FL | PU | 34900 | F21Q12497620 | N | 360 | 2 | Other sellers | Other servicers | NaN | NaN | 9 | NaN | 2 | N | N |